Name |
Code |
Parent Table |
Child Table |
Foreign Key Columns |
Parent Role |
Child Role |
ServID |
|
|
||||
EventID |
|
|
||||
FrequencyID |
|
|
||||
PersonID |
|
|
||||
ReservationStatusID |
|
|
||||
ReservationStatusID |
|
|
||||
ReservationID |
|
|
||||
ReservationID |
|
|
||||
Res_ReservationID |
|
|
||||
TimePatternID |
|
|
||||
Tim_TimePatternID |
|
|
||||
TimePatternID |
|
|
||||
FrequencyID |
|
|
||||
TimeslotTypeID |
|
|
||||
TimePatternID |
|
|
||||
ServID; TimePatternID |
|
|
||||
ServID |
|
|
||||
ServID |
|
|
||||
VisitTypeID |
|
|
||||
VisitTypeID |
|
|
||||
ServID |
|
|
||||
VisitTypeID |
|
|
||||
ServID |
|
|
||||
TimePatternTimeSlotID |
|
|
||||
TimePatternTimeSlotID |
|
|
||||
MedResourceID |
|
|
||||
MedResourceID |
|
|
||||
Sex |
|
|
||||
ReservationID |
|
|
||||
TimePatternTimeSlotID |
|
|
||||
Sex |
|
|
||||
VisitCancelReasonID |
|
|
||||
VisitCancelReasonID |
|
|
||||
Tim_TimePatternTimeSlotID |
|
|
||||
TimePatternID |
|
|
||||
MedResourceID |
|
|
||||
LServiceTimePatternTimeslotID |
|
|
||||
VisitTypeID |
|
|
||||
ReservationStatusID |
|
|
||||
PriceListID |
|
|
||||
TimeStampID |
|
|
||||
TimeStampID |
|
|
||||
PersonID |
|
|
||||
PerfServiceID |
|
|
||||
TimeStampTypeID |
|
|
||||
TimeStampTypeID |
|
|
||||
TimePatternTimeSlotID |
|
|
||||
PersonID |
|
|
||||
DayIntervalID |
|
|
||||
ServID |
|
|
|
|
|